﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ServiceOrderPull.aspx.vb"
    Inherits="Reports_ServiceOrderPull" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%--<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>
--%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Team Report Card</title>
    <link type="text/css" href="css/redmond/jquery-ui-1.7.2.custom.css" rel="stylesheet" />
    <script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
    <script type="text/javascript" src="js/jquery-ui-1.7.2.custom.min.js"></script>
    <script type="text/javascript" src="js/Reports.js"></script>
    <link href="css/RollUp.css" rel="stylesheet" type="text/css" />
    <link href="../styles/acc.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .style1
        {
            width: 112px;
            height: 46px;
        }
        .style2
        {
            height: 46px;
        }
    </style>
</head>
<body style="font: normal 9pt Calabri, Arial, San-Serif;">
    <form id="form1" runat="server">
    <%--   <p><h3>&nbsp;</h3><br /><%=DateTime.Today.ToString("MMMM yyyy") %> (<%=DateTime.Today.Day%> day of month)</p>--%>
    <div style="display: none">
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
    </div>
    <center>
        <div>
            <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="9pt"
                InteractiveDeviceInfos="(Collection)" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="12pt"
                Width="100%" PageCountMode="Actual" ShowZoomControl="False">
                <LocalReport ReportPath="reports\SSRS\TeamReportCard.rdlc" 
                    EnableHyperlinks="True">
                </LocalReport>
            </rsweb:ReportViewer>
        </div>
        <asp:Panel ID="divRegions" runat="server" Style="position: absolute; top: 6px; right: 20px">
            <table cellpadding="0" cellspacing="0" style="border-collapse: collapse">
                <tr>
                    <td>
                        &nbsp;&nbsp;<asp:Label ID="Label2" runat="server" Text="From:" Font-Names="Segoe UI"
                            Font-Size="9pt" ForeColor="#999999" />
                    </td>
                    <td>
                        <asp:TextBox ID="txtFrom" runat="server" Font-Names="Segoe UI" Font-Size="9pt" ForeColor="#999999"
                            Height="20px" Width="68px"></asp:TextBox>
                    </td>
                    <td>
                        &nbsp;&nbsp;<asp:Label ID="Label3" runat="server" Text="To:" Font-Names="Segoe UI"
                            Font-Size="9pt" ForeColor="#999999" />
                    </td>
                    <td align="right">
                        &nbsp;&nbsp;<asp:TextBox ID="txtTo" runat="server" Font-Names="Segoe UI" Font-Size="9pt"
                            ForeColor="#999999" Height="20px" Width="68px"></asp:TextBox>
                    </td>
                    <td valign="middle">
                        
                        <asp:CheckBoxList ID="chlProducts" runat="server" CellPadding="0" CellSpacing="1"
                            Style="margin-left: 4px;display:none" RepeatDirection="Horizontal" Font-Names="Segoe UI"
                            Font-Size="9pt" ForeColor="#999999"  Height="20px" >
                            <asp:ListItem Selected="True">HSIA</asp:ListItem>
                            <asp:ListItem Selected="True">IPTV</asp:ListItem>
                            <asp:ListItem Selected="True">VOIP</asp:ListItem>
                        </asp:CheckBoxList>
                    </td>
                    <td class="style2">
                        &nbsp;&nbsp;<asp:Label ID="Label1" runat="server" Text="Acct Mgr:" Font-Names="Segoe UI"
                            Font-Size="9pt" ForeColor="#999999"></asp:Label>
                    </td>
                    <td class="style1">
                        <asp:DropDownList ID="ddlRegions" runat="server" AutoPostBack="True" 
                            Font-Names="Segoe UI" DataSourceID="odsManagers"
                            Font-Size="9pt" ForeColor="#999999" DataTextField="TXT" 
                            DataValueField="VAL" AppendDataBoundItems="True">
<asp:ListItem Selected="True">Select a Region or Acct Mgr</asp:ListItem>
<%--                            <asp:ListItem Selected="True">Select...</asp:ListItem>
                            <asp:ListItem>ALL REGIONS</asp:ListItem>
                            <asp:ListItem>EAST</asp:ListItem>
                            <asp:ListItem>MIDWEST</asp:ListItem>
                            <asp:ListItem>SOUTHEAST</asp:ListItem>
                            <asp:ListItem>SOUTHWEST</asp:ListItem>
                            <asp:ListItem>WEST</asp:ListItem>--%>
                        </asp:DropDownList>
                    </td>
 <%--                   <td>
                        &nbsp;&nbsp;<asp:Label ID="Label21" runat="server" Text="Acct Mgr:" Font-Names="Segoe UI"
                            Font-Size="9pt" ForeColor="#999999" />
                    </td>
                    <td>
                        <asp:DropDownList ID="ddlAcctMgrs" runat="server" AutoPostBack="True" Font-Names="Segoe UI"
                            Font-Size="9pt" ForeColor="#999999" />
                    </td>--%>
                    <td>
                    <asp:ImageButton class="pushbutton" ID="imgbtnRefresh1" runat="server" ImageUrl="~/images/Refresh1.png" style="position:relative;top:3px;left:3px"
                        ToolTip="Refresh Rollup Data" OnClick="imgbtnRefresh1_Click" />
                    </td>
                </tr>
            </table>
        </asp:Panel>
        <cc1:CalendarExtender ID="calStart" runat="server" TargetControlID="txtFrom">
        </cc1:CalendarExtender>
        <cc1:CalendarExtender ID="calEnd" runat="server" TargetControlID="txtTo">
        </cc1:CalendarExtender>
    </center>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ACC_NEW %>"
        SelectCommand="SELECT * FROM ORDERS_VIEW WHERE ACCT_MGR LIKE LTRIM(SUBSTRING(@ACCT_MGR,1, CHARINDEX(':', @ACCT_MGR)-1)) AND START_DT BETWEEN @START_DATE AND @END_DATE">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddlRegions" DefaultValue="%" Name="ACCT_MGR" 
                PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="txtFrom" DefaultValue="" Name="START_DATE" 
                PropertyName="Text" />
            <asp:ControlParameter ControlID="txtTo" Name="END_DATE" PropertyName="Text" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:ObjectDataSource ID="odsManagers" runat="server" SelectMethod="dvACC_DATA"
        TypeName="Menus"
        OldValuesParameterFormatString="original_{0}">
        <SelectParameters>
            <asp:Parameter DefaultValue="Manager" Name="psFirstLevelName" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>
    </form>
</body>
</html>
